Some PivotTable list features are available only when you're working in the design program. Other features are available both while designing the PivotTable list and while using it in a browser. However, as a designer, you can restrict the availability of these features to a user by changing property settings.
Regardless of the capabilities you have made available to the users, whether users can take advantage of those capabilities depends on what browser they are running. To take full advantage of the capabilities of PivotTable lists, users need Microsoft Internet Explorer version 4.01 or later.
Capabilities that are not available in a browser
In the browser, users cannot change information about the source database, database fields, and source data.
Only the designer of a PivotTable list can specify what source database to use and what subset of the data to make available as the source data in the PivotTable list.
In the browser, users can display only the data you've made available; if a password is required to access the database, users must enter the password to display the data. Users can refresh the PivotTable list in the browser to reflect any changes in the source data, but they cannot gain more general access to the source database or make any changes to the data it stores.
Capabilities that are usually available in the browser
If their browser fully supports PivotTable lists, users can make many of the same changes to the PivotTable list in the browser that you can make in the design program.
Subject to any restrictions you set when you design the PivotTable list, the user can add or move fields from the field list, change the layout, sort, filter, and group data. Users can analyze the data and create summaries, just as you can in the design program.
To prevent users from making changes to a PivotTable list or accessing portions of the source data that you don't want to make available, you can prevent them from doing the following: